using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VVSTAW
    {
        public DataRow Convert2VSTAW(DataRow dwInput, string ITXDBVERSION, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryVSTAW(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].NewRow();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                    #region=========
         dwReturn["VAWMANDANT"] = " ".PadRight(2 ); 
         dwReturn["VAWSL"] = " ".PadRight(3 ); 
         dwReturn["VAWTITEL"] = " ".PadRight(60 ); 
         dwReturn["VAWSUMMEN"] = " ".PadRight(1 ); 
         dwReturn["VAWABW"] = " ".PadRight(1 ); 
         dwReturn["VAWZEITRAUM"] = " ".PadRight(1 ); 
         dwReturn["VAWUMSATZ"] = " ".PadRight(1 ); 
         dwReturn["VAWMEEH"] = " ".PadRight(3 ); 
         dwReturn["VAWMEEHGRP"] = " ".PadRight(1 ); 
         dwReturn["VAWMEEHFKT"] = " ".PadRight(12 ); 
         dwReturn["VAWPREH"] = " ".PadRight(3 ); 
         dwReturn["VAWPREHGRP"] = " ".PadRight(1 ); 
         dwReturn["VAWPREHFKT"] = " ".PadRight(12 ); 
         dwReturn["VAWSTTYP"] = " ".PadRight(1 ); 
         dwReturn["VAWKUMSATZ"] = " ".PadRight(1 ); 
         dwReturn["VAWKMENGE"] = " ".PadRight(1 ); 
         dwReturn["VAWKPREIS"] = " ".PadRight(1 ); 
         dwReturn["VAWKHK"] = " ".PadRight(1 ); 
         dwReturn["VAWTHK"] = " ".PadRight(1 ); 
         dwReturn["VAWHKTAB1"] = " ".PadRight(1 ); 
         dwReturn["VAWHKTAB2"] = " ".PadRight(1 ); 
         dwReturn["VAWHKTAB3"] = " ".PadRight(1 ); 
         dwReturn["VAWHKTAB4"] = " ".PadRight(1 ); 
         dwReturn["VAWHKTAB5"] = " ".PadRight(1 ); 
         dwReturn["VAWHKTAB6"] = " ".PadRight(1 ); 
         dwReturn["VAWKDB"] = " ".PadRight(1 ); 
         dwReturn["VAWTDB"] = " ".PadRight(1 ); 
         dwReturn["VAWDBTAB1"] = " ".PadRight(1 ); 
         dwReturn["VAWDBTAB2"] = " ".PadRight(1 ); 
         dwReturn["VAWDBTAB3"] = " ".PadRight(1 ); 
         dwReturn["VAWDBTAB4"] = " ".PadRight(1 ); 
         dwReturn["VAWDBTAB5"] = " ".PadRight(1 ); 
         dwReturn["VAWDBTAB6"] = " ".PadRight(1 ); 
         dwReturn["VAWKVPROV"] = " ".PadRight(1 ); 
         dwReturn["VAWTVPROV"] = " ".PadRight(1 ); 
         dwReturn["VAWKFRACHT"] = " ".PadRight(1 ); 
         dwReturn["VAWTFRACHT"] = " ".PadRight(1 ); 
         dwReturn["VAWKVERP"] = " ".PadRight(1 ); 
         dwReturn["VAWTVERP"] = " ".PadRight(1 ); 
         dwReturn["VAWKRABATT"] = " ".PadRight(1 ); 
         dwReturn["VAWTRABATT"] = " ".PadRight(1 ); 
         dwReturn["VAWKVERSICH"] = " ".PadRight(1 ); 
         dwReturn["VAWTVERSICH"] = " ".PadRight(1 ); 
         dwReturn["VAWKZUAB"] = " ".PadRight(1 ); 
         dwReturn["VAWTZUAB"] = " ".PadRight(1 ); 
         dwReturn["VAWAUFBER"] = " ".PadRight(2 ); 
         dwReturn["VAWRANKING"] = " ".PadRight(1 ); 
         dwReturn["VAWABSART"] = " ".PadRight(3 ); 
         dwReturn["VAWRGRQM"] = " ".PadRight(0 ); 
         dwReturn["VAWFGRQM"] = " ".PadRight(0 ); 
         dwReturn["VAWRFDDIS"] = " ".PadRight(0 ); 
         dwReturn["VAWKVB"] = " ".PadRight(1 ); 
         dwReturn["VAWVBV"] = " ".PadRight(3 ); 
         dwReturn["VAWVBB"] = " ".PadRight(3 ); 
         dwReturn["VAWSVB"] = " ".PadRight(1 ); 
         dwReturn["VAWVVB"] = " ".PadRight(1 ); 
         dwReturn["VAWKVG"] = " ".PadRight(1 ); 
         dwReturn["VAWVGV"] = " ".PadRight(3 ); 
         dwReturn["VAWVGB"] = " ".PadRight(3 ); 
         dwReturn["VAWSVG"] = " ".PadRight(1 ); 
         dwReturn["VAWVVG"] = " ".PadRight(1 ); 
         dwReturn["VAWKVERTNR"] = " ".PadRight(1 ); 
         dwReturn["VAWVERTNRV"] = " ".PadRight(8 ); 
         dwReturn["VAWVERTNRB"] = " ".PadRight(8 ); 
         dwReturn["VAWSVERTNR"] = " ".PadRight(1 ); 
         dwReturn["VAWVVERTNR"] = " ".PadRight(1 ); 
         dwReturn["VAWKPROJNR"] = " ".PadRight(1 ); 
         dwReturn["VAWPROJNR"] = " ".PadRight(5 ); 
         dwReturn["VAWSPROJNR"] = " ".PadRight(1 ); 
         dwReturn["VAWVPROJNR"] = " ".PadRight(1 ); 
         dwReturn["VAWKKZINLEXP"] = " ".PadRight(1 ); 
         dwReturn["VAWKZINLEXP"] = " ".PadRight(1 ); 
         dwReturn["VAWSINLEXP"] = " ".PadRight(1 ); 
         dwReturn["VAWVINLEXP"] = " ".PadRight(1 ); 
         dwReturn["VAWKLAND"] = " ".PadRight(1 ); 
         dwReturn["VAWLAND"] = " ".PadRight(3 ); 
         dwReturn["VAWSLAND"] = " ".PadRight(1 ); 
         dwReturn["VAWVLAND"] = " ".PadRight(1 ); 
         dwReturn["VAWKWR"] = " ".PadRight(1 ); 
         dwReturn["VAWWR"] = " ".PadRight(3 ); 
         dwReturn["VAWSWR"] = " ".PadRight(1 ); 
         dwReturn["VAWVWR"] = " ".PadRight(1 ); 
         dwReturn["VAWKGEBIET"] = " ".PadRight(1 ); 
         dwReturn["VAWGEBIET"] = " ".PadRight(3 ); 
         dwReturn["VAWSGEBIET"] = " ".PadRight(1 ); 
         dwReturn["VAWVGEBIET"] = " ".PadRight(1 ); 
         dwReturn["VAWKPLZ"] = " ".PadRight(1 ); 
         dwReturn["VAWPLZV"] = " ".PadRight(12 ); 
         dwReturn["VAWPLZB"] = " ".PadRight(12 ); 
         dwReturn["VAWSPLZ"] = " ".PadRight(1 ); 
         dwReturn["VAWVPLZ"] = " ".PadRight(1 ); 
         dwReturn["VAWKCOUNTY"] = " ".PadRight(1 ); 
         dwReturn["VAWCOUNTYV"] = " ".PadRight(4 ); 
         dwReturn["VAWCOUNTYB"] = " ".PadRight(4 ); 
         dwReturn["VAWSCOUNTY"] = " ".PadRight(1 ); 
         dwReturn["VAWVCOUNTY"] = " ".PadRight(1 ); 
         dwReturn["VAWKCITY"] = " ".PadRight(1 ); 
         dwReturn["VAWCITYV"] = " ".PadRight(4 ); 
         dwReturn["VAWCITYB"] = " ".PadRight(4 ); 
         dwReturn["VAWSCITY"] = " ".PadRight(1 ); 
         dwReturn["VAWVCITY"] = " ".PadRight(1 ); 
         dwReturn["VAWKABNGRP"] = " ".PadRight(1 ); 
         dwReturn["VAWABNGRP"] = " ".PadRight(3 ); 
         dwReturn["VAWSABNGRP"] = " ".PadRight(1 ); 
         dwReturn["VAWVABNGRP"] = " ".PadRight(1 ); 
         dwReturn["VAWKABNGST"] = " ".PadRight(1 ); 
         dwReturn["VAWABNGRPST"] = " ".PadRight(3 ); 
         dwReturn["VAWSABNGST"] = " ".PadRight(1 ); 
         dwReturn["VAWVABNGST"] = " ".PadRight(1 ); 
         dwReturn["VAWKVERBNR"] = " ".PadRight(1 ); 
         dwReturn["VAWZENTRRV"] = " ".PadRight(1 ); 
         dwReturn["VAWVERBNR"] = " ".PadRight(8 ); 
         dwReturn["VAWSVERBNR"] = " ".PadRight(1 ); 
         dwReturn["VAWVVERBNR"] = " ".PadRight(1 ); 
         dwReturn["VAWKZENTR"] = " ".PadRight(1 ); 
         dwReturn["VAWZENTRRZ"] = " ".PadRight(1 ); 
         dwReturn["VAWZENTR"] = " ".PadRight(8 ); 
         dwReturn["VAWSZENTR"] = " ".PadRight(1 ); 
         dwReturn["VAWVZENTR"] = " ".PadRight(1 ); 
         dwReturn["VAWKKUNDST"] = " ".PadRight(1 ); 
         dwReturn["VAWKUNDNRST"] = " ".PadRight(8 ); 
         dwReturn["VAWSKUNDST"] = " ".PadRight(1 ); 
         dwReturn["VAWVKUNDST"] = " ".PadRight(1 ); 
         dwReturn["VAWKSACHBE"] = " ".PadRight(1 ); 
         dwReturn["VAWSACHBE"] = " ".PadRight(8 ); 
         dwReturn["VAWSSACHBE"] = " ".PadRight(1 ); 
         dwReturn["VAWVSACHBE"] = " ".PadRight(1 ); 
         dwReturn["VAWKKUNDNR"] = " ".PadRight(1 ); 
         dwReturn["VAWKUNDNR"] = " ".PadRight(8 ); 
         dwReturn["VAWSKUNDNR"] = " ".PadRight(1 ); 
         dwReturn["VAWVKUNDNR"] = " ".PadRight(1 ); 
         dwReturn["VAWKBRANCHE"] = " ".PadRight(1 ); 
         dwReturn["VAWBRANCHE"] = " ".PadRight(3 ); 
         dwReturn["VAWSBRANCHE"] = " ".PadRight(1 ); 
         dwReturn["VAWVBRANCHE"] = " ".PadRight(1 ); 
         dwReturn["VAWKABCKL"] = " ".PadRight(1 ); 
         dwReturn["VAWABCKL1"] = " ".PadRight(1 ); 
         dwReturn["VAWABCKL2"] = " ".PadRight(1 ); 
         dwReturn["VAWABCKL3"] = " ".PadRight(1 ); 
         dwReturn["VAWSABCKL"] = " ".PadRight(1 ); 
         dwReturn["VAWVABCKL"] = " ".PadRight(1 ); 
         dwReturn["VAWKPOSTYP"] = " ".PadRight(1 ); 
         dwReturn["VAWPOSTYP"] = " ".PadRight(3 ); 
         dwReturn["VAWSPOSTYP"] = " ".PadRight(1 ); 
         dwReturn["VAWVPOSTYP"] = " ".PadRight(1 ); 
         dwReturn["VAWKCOUPON"] = " ".PadRight(1 ); 
         dwReturn["VAWCOUPON"] = " ".PadRight(1 ); 
         dwReturn["VAWSCOUPON"] = " ".PadRight(1 ); 
         dwReturn["VAWVCOUPON"] = " ".PadRight(1 ); 
         dwReturn["VAWKORDER"] = " ".PadRight(1 ); 
         dwReturn["VAWORDER"] = " ".PadRight(4 ); 
         dwReturn["VAWSORDER"] = " ".PadRight(1 ); 
         dwReturn["VAWVORDER"] = " ".PadRight(1 ); 
         dwReturn["VAWKPRGRP"] = " ".PadRight(1 ); 
         dwReturn["VAWPRGRP"] = " ".PadRight(8 ); 
         dwReturn["VAWSPRGRP"] = " ".PadRight(1 ); 
         dwReturn["VAWVPRGRP"] = " ".PadRight(1 ); 
         dwReturn["VAWKGRUND"] = " ".PadRight(1 ); 
         dwReturn["VAWGRUNDV"] = " ".PadRight(3 ); 
         dwReturn["VAWGRUNDB"] = " ".PadRight(3 ); 
         dwReturn["VAWSGRUND"] = " ".PadRight(1 ); 
         dwReturn["VAWVGRUND"] = " ".PadRight(1 ); 
         dwReturn["VAWKPRDGR"] = " ".PadRight(1 ); 
         dwReturn["VAWPRDGR"] = " ".PadRight(3 ); 
         dwReturn["VAWSPRDGR"] = " ".PadRight(1 ); 
         dwReturn["VAWVPRDGR"] = " ".PadRight(1 ); 
         dwReturn["VAWKARTGRP"] = " ".PadRight(1 ); 
         dwReturn["VAWARTGRP"] = " ".PadRight(3 ); 
         dwReturn["VAWSARTGRP"] = " ".PadRight(1 ); 
         dwReturn["VAWVARTGRP"] = " ".PadRight(1 ); 
         dwReturn["VAWKZIELGR"] = " ".PadRight(1 ); 
         dwReturn["VAWZIELGR"] = " ".PadRight(4 ); 
         dwReturn["VAWSZIELGR"] = " ".PadRight(1 ); 
         dwReturn["VAWVZIELGR"] = " ".PadRight(1 ); 
         dwReturn["VAWKOBERKOLL"] = " ".PadRight(1 ); 
         dwReturn["VAWOBERKOLL"] = " ".PadRight(5 ); 
         dwReturn["VAWSOBERKOLL"] = " ".PadRight(1 ); 
         dwReturn["VAWVOBERKOLL"] = " ".PadRight(1 ); 
         dwReturn["VAWKKOLL"] = " ".PadRight(1 ); 
         dwReturn["VAWKOLL"] = " ".PadRight(5 ); 
         dwReturn["VAWSKOLL"] = " ".PadRight(1 ); 
         dwReturn["VAWVKOLL"] = " ".PadRight(1 ); 
         dwReturn["VAWKVART"] = " ".PadRight(1 ); 
         dwReturn["VAWVART"] = " ".PadRight(24 ); 
         dwReturn["VAWSVART"] = " ".PadRight(1 ); 
         dwReturn["VAWVVART"] = " ".PadRight(1 ); 
         dwReturn["VAWKVFARBE"] = " ".PadRight(1 ); 
         dwReturn["VAWVFARBEV"] = " ".PadRight(10 ); 
         dwReturn["VAWVFARBEB"] = " ".PadRight(10 ); 
         dwReturn["VAWSVFARBE"] = " ".PadRight(1 ); 
         dwReturn["VAWVVFARBE"] = " ".PadRight(1 ); 
         dwReturn["VAWKGROE"] = " ".PadRight(1 ); 
         dwReturn["VAWGROE"] = " ".PadRight(7 ); 
         dwReturn["VAWSGROE"] = " ".PadRight(1 ); 
         dwReturn["VAWVGROE"] = " ".PadRight(1 ); 
         dwReturn["VAWKVZENSUR"] = " ".PadRight(1 ); 
         dwReturn["VAWVZENSURV"] = " ".PadRight(1 ); 
         dwReturn["VAWVZENSURB"] = " ".PadRight(1 ); 
         dwReturn["VAWSVZENSUR"] = " ".PadRight(1 ); 
         dwReturn["VAWVVZENSUR"] = " ".PadRight(1 ); 
         dwReturn["VAWKVAUFMART"] = " ".PadRight(1 ); 
         dwReturn["VAWVAUFMART"] = " ".PadRight(2 ); 
         dwReturn["VAWSVAUFMART"] = " ".PadRight(1 ); 
         dwReturn["VAWVVAUFMART"] = " ".PadRight(1 ); 
         dwReturn["VAWKVERPSL"] = " ".PadRight(1 ); 
         dwReturn["VAWVERPSL"] = " ".PadRight(3 ); 
         dwReturn["VAWSVERPSL"] = " ".PadRight(1 ); 
         dwReturn["VAWVVERPSL"] = " ".PadRight(1 ); 
         dwReturn["VAWKLIEFSG"] = " ".PadRight(1 ); 
         dwReturn["VAWLIEFSG"] = " ".PadRight(1 ); 
         dwReturn["VAWSLIEFSG"] = " ".PadRight(1 ); 
         dwReturn["VAWVLIEFSG"] = " ".PadRight(1 ); 
         dwReturn["VAWKWRKABT"] = " ".PadRight(1 ); 
         dwReturn["VAWWERK"] = " ".PadRight(3 ); 
         dwReturn["VAWABT"] = " ".PadRight(3 ); 
         dwReturn["VAWSWRKABT"] = " ".PadRight(1 ); 
         dwReturn["VAWVWRKABT"] = " ".PadRight(1 ); 
         dwReturn["VAWKDART"] = " ".PadRight(1 ); 
         dwReturn["VAWDART"] = " ".PadRight(20 ); 
         dwReturn["VAWDVAR"] = " ".PadRight(2 ); 
         dwReturn["VAWSDART"] = " ".PadRight(1 ); 
         dwReturn["VAWVDART"] = " ".PadRight(1 ); 
         dwReturn["VAWKPART"] = " ".PadRight(1 ); 
         dwReturn["VAWPWAKZ"] = " ".PadRight(1 ); 
         dwReturn["VAWPART"] = " ".PadRight(20 ); 
         dwReturn["VAWPVAR"] = " ".PadRight(2 ); 
         dwReturn["VAWSPART"] = " ".PadRight(1 ); 
         dwReturn["VAWVPART"] = " ".PadRight(1 ); 
         dwReturn["VAWKPLART"] = " ".PadRight(1 ); 
         dwReturn["VAWPLART"] = " ".PadRight(20 ); 
         dwReturn["VAWSPLART"] = " ".PadRight(1 ); 
         dwReturn["VAWVPLART"] = " ".PadRight(1 ); 
         dwReturn["VAWKFFARBE"] = " ".PadRight(1 ); 
         dwReturn["VAWFFARBE"] = " ".PadRight(10 ); 
         dwReturn["VAWSFFARBE"] = " ".PadRight(1 ); 
         dwReturn["VAWVFFARBE"] = " ".PadRight(1 ); 
         dwReturn["VAWKDESS"] = " ".PadRight(1 ); 
         dwReturn["VAWDESS"] = " ".PadRight(10 ); 
         dwReturn["VAWSDESS"] = " ".PadRight(1 ); 
         dwReturn["VAWVDESS"] = " ".PadRight(1 ); 
         dwReturn["VAWKCOLORIT"] = " ".PadRight(1 ); 
         dwReturn["VAWCOLORIT"] = " ".PadRight(10 ); 
         dwReturn["VAWSCOLORIT"] = " ".PadRight(1 ); 
         dwReturn["VAWVCOLORIT"] = " ".PadRight(1 ); 
         dwReturn["VAWKBESCHICH"] = " ".PadRight(1 ); 
         dwReturn["VAWBESCHICH"] = " ".PadRight(10 ); 
         dwReturn["VAWSBESCHICH"] = " ".PadRight(1 ); 
         dwReturn["VAWVBESCHICH"] = " ".PadRight(1 ); 
         dwReturn["VAWVONST"] = " ".PadRight(2 ); 
         dwReturn["VAWANZST"] = " ".PadRight(2 ); 
         dwReturn["VAWKUMSATZ4"] = " ".PadRight(1 ); 
         dwReturn["VAWUMSATZV"] = " ".PadRight(0 ); 
         dwReturn["VAWUMSATZB"] = " ".PadRight(0 ); 
         dwReturn["VAWSUMSATZ"] = " ".PadRight(1 ); 
         dwReturn["VAWVUMSATZ"] = " ".PadRight(1 ); 
         dwReturn["VAWKDB4"] = " ".PadRight(1 ); 
         dwReturn["VAWINDEX"] = " ".PadRight(1 ); 
         dwReturn["VAWDBV"] = " ".PadRight(0 ); 
         dwReturn["VAWDBB"] = " ".PadRight(0 ); 
         dwReturn["VAWSDB4"] = " ".PadRight(1 ); 
         dwReturn["VAWVDB4"] = " ".PadRight(1 ); 
         dwReturn["VAWKLITERM"] = " ".PadRight(1 ); 
         dwReturn["VAWLITERMV"] = " ".PadRight(8 ); 
         dwReturn["VAWLITERMB"] = " ".PadRight(8 ); 
         dwReturn["VAWSLITERM"] = " ".PadRight(1 ); 
         dwReturn["VAWVLITERM"] = " ".PadRight(1 ); 
         dwReturn["VAWKAUFTR"] = " ".PadRight(1 ); 
         dwReturn["VAWAUFKRS"] = " ".PadRight(2 ); 
         dwReturn["VAWAUFLFD"] = " ".PadRight(6 ); 
         dwReturn["VAWAUFPOS"] = " ".PadRight(3 ); 
         dwReturn["VAWSAUFTR"] = " ".PadRight(1 ); 
         dwReturn["VAWVAUFTR"] = " ".PadRight(1 ); 
         dwReturn["VAWKRECH"] = " ".PadRight(1 ); 
         dwReturn["VAWRENR"] = " ".PadRight(8 ); 
         dwReturn["VAWREPOS"] = " ".PadRight(1 ); 
         dwReturn["VAWREDAT"] = " ".PadRight(1 ); 
         dwReturn["VAWSRECH"] = " ".PadRight(1 ); 
         dwReturn["VAWVRECH"] = " ".PadRight(1 ); 
         dwReturn["VAWKVZOLLTNR"] = " ".PadRight(1 ); 
         dwReturn["VAWVZOLLTNR"] = " ".PadRight(20 ); 
         dwReturn["VAWSVZOLLTNR"] = " ".PadRight(1 ); 
         dwReturn["VAWVVZOLLTNR"] = " ".PadRight(1 ); 
         dwReturn["VAWKSTATWNR"] = " ".PadRight(1 ); 
         dwReturn["VAWSTATWNR"] = " ".PadRight(12 ); 
         dwReturn["VAWSSTATWNR"] = " ".PadRight(1 ); 
         dwReturn["VAWVSTATWNR"] = " ".PadRight(1 ); 
         dwReturn["VAWKBUSIMODE"] = " ".PadRight(1 ); 
         dwReturn["VAWBUSIMODE"] = " ".PadRight(3 ); 
         dwReturn["VAWSBUSIMODE"] = " ".PadRight(1 ); 
         dwReturn["VAWVBUSIMODE"] = " ".PadRight(1 ); 
         dwReturn["VAWKTITER"] = " ".PadRight(1 ); 
         dwReturn["VAWNUMART"] = " ".PadRight(4 ); 
         dwReturn["VAWGARNNR1"] = " ".PadRight(5 ); 
         dwReturn["VAWGARNNR2"] = " ".PadRight(1 ); 
         dwReturn["VAWSTITER"] = " ".PadRight(1 ); 
         dwReturn["VAWVTITER"] = " ".PadRight(1 ); 
         dwReturn["VAWKURSPPART"] = " ".PadRight(1 ); 
         dwReturn["VAWURSPPART"] = " ".PadRight(10 ); 
         dwReturn["VAWSURSPPART"] = " ".PadRight(1 ); 
         dwReturn["VAWVURSPPART"] = " ".PadRight(1 ); 
         dwReturn["VAWKSPPART"] = " ".PadRight(1 ); 
         dwReturn["VAWSPPART"] = " ".PadRight(10 ); 
         dwReturn["VAWSSPPART"] = " ".PadRight(1 ); 
         dwReturn["VAWVSPPART"] = " ".PadRight(1 ); 
         dwReturn["VAWKKUNDNRKO"] = " ".PadRight(1 ); 
         dwReturn["VAWKUNDNRKO"] = " ".PadRight(8 ); 
         dwReturn["VAWSKUNDNRKO"] = " ".PadRight(1 ); 
         dwReturn["VAWVKUNDNRKO"] = " ".PadRight(1 ); 
         dwReturn["VAWKFARBGRP"] = " ".PadRight(1 ); 
         dwReturn["VAWFARBGRP"] = " ".PadRight(1 ); 
         dwReturn["VAWSFARBGRP"] = " ".PadRight(1 ); 
         dwReturn["VAWVFARBGRP"] = " ".PadRight(1 ); 
         dwReturn["VAWKKDKOLL"] = " ".PadRight(1 ); 
         dwReturn["VAWKDKOLL"] = " ".PadRight(5 ); 
         dwReturn["VAWSKDKOLL"] = " ".PadRight(1 ); 
         dwReturn["VAWVKDKOLL"] = " ".PadRight(1 ); 
         dwReturn["VAWKMKOLL"] = " ".PadRight(1 ); 
         dwReturn["VAWMKOLL"] = " ".PadRight(5 ); 
         dwReturn["VAWSMKOLL"] = " ".PadRight(1 ); 
         dwReturn["VAWVMKOLL"] = " ".PadRight(1 ); 
         dwReturn["VAWFILLER2"] = " ".PadRight(143 ); 
         dwReturn["VAWSEITE"] = " ".PadRight(1 ); 
         dwReturn["VAWKUNDKZ"] = " ".PadRight(1 ); 
         dwReturn["VAWVARTKZ"] = " ".PadRight(1 ); 
         dwReturn["VAWUMSATZKZ"] = " ".PadRight(1 ); 
         dwReturn["VAWKZKUNDE"] = " ".PadRight(1 ); 
         dwReturn["VAWMATKOMP"] = " ".PadRight(1 ); 
         dwReturn["VAWKMORD"] = " ".PadRight(1 ); 
         dwReturn["VAWSMORD"] = " ".PadRight(1 ); 
         dwReturn["VAWVMORD"] = " ".PadRight(1 ); 
         dwReturn["VAWFILLER"] = " ".PadRight(204 ); 
         dwReturn["VAWAENZL"] = " ".PadRight(0 ); 
         dwReturn["VAWAENB"] = " ".PadRight(8 ); 
         dwReturn["VAWAEND"] = " ".PadRight(0 ); 
         dwReturn["VAWNEUB"] = " ".PadRight(8 ); 
         dwReturn["VAWNEUD"] = " ".PadRight(0 ); 
                    #endregion
                    break;
                case "JLT":

                    break;
                default:

                    break;
            }
            if (IsConvert)
            {
                foreach (DataColumn cm in dwInput.Table.Columns)
                {
                    if (dwInput[cm.ColumnName].ToString() == "")
                        continue;
                    if (dwReturn.Table.Columns.Contains(cm.ColumnName))
                    {
                        dwReturn[cm.ColumnName] = dwInput[cm.ColumnName];
                    }
                }
            }
            return dwReturn;
        }
        public void MapVSTAW(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void SaveVSTAW(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryVSTAW(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapVSTAW(ref dwLocal, dwData);

            if (!flgExist)
            {

                InsertVSTAW(dwLocal, ITXDBVERSION);
            }
            UpdateVSTAW(dwLocal);
        }
        public void InsertVSTAW(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                    or1.CommandText = "INSERT INTO VSTAW(VAKBMANDANT, VAKBKOLL, VAKBART, VAKBKUNDNR, VAKBFARBE, VAKBKDARTNR, VAKBKDARTBEZ, VAKBKDFARBNR, VAKBANDRUCK, VAKBMEGEW, VAKBMENGEH, VAKBGEWVON, VAKBGEWBIS, VAKBGEWCA, VAKBGEWFKT, VAKBGEWGRP, VAKBMEGFKT, VAKBMEGGRP, VAKBAENDZL, VAKBAENDBEN, VAKBAENDDAT, VAKBNEUBEN, VAKBNEUDAT, VAKBFILLER)"
                        + " VALUES (:VAKBMANDANT, :VAKBKOLL, :VAKBART, :VAKBKUNDNR, :VAKBFARBE, '                         ', '                         ', '                             ', ' ', '   ', '   ', 0, 0, ' ', '000000000000', ' ', '000000000000', ' ', 0, '        ', '000000', '        ', '      ', '                                          ')";
                    or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                //VAFMANDANT VAFKOLL VAFART VAFFARBE VAFBEZ VAFFFARBE

            }
            
            Connect2Proxy(or1);
        }
        public DataSet QueryVSTAW(DataRow dwData, int option = 1)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM VSTAW WHERE  ROWNUM<2 ";
                    break;
              
                case 99:
                    or1.CommandText = "SELECT * FROM VSTAW  WHERE ROWNUM<50";
                    break;
                default:
                    break;
            }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "VSTAW";
            Return = Result;
            return Return;
        }
        public void DeleteVSTAW(DataRow dwData, int option = 1)
        {

            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM VSTAW   WHERE  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                     or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        } 
      
        public void UpdateVSTAW(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            OracleCommand or1;
            DataSet Result = new DataSet();
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command==== 
                    or1.CommandText = "UPDATE VSTAW SET "
                    +"VAWMANDANT= :VAWMANDANT,"
                    +"VAWSL= :VAWSL,"
                    +"VAWTITEL= :VAWTITEL,"
                    +"VAWSUMMEN= :VAWSUMMEN,"
                    +"VAWABW= :VAWABW,"
                    +"VAWZEITRAUM= :VAWZEITRAUM,"
                    +"VAWUMSATZ= :VAWUMSATZ,"
                    +"VAWMEEH= :VAWMEEH,"
                    +"VAWMEEHGRP= :VAWMEEHGRP,"
                    +"VAWMEEHFKT= :VAWMEEHFKT,"
                    +"VAWPREH= :VAWPREH,"
                    +"VAWPREHGRP= :VAWPREHGRP,"
                    +"VAWPREHFKT= :VAWPREHFKT,"
                    +"VAWSTTYP= :VAWSTTYP,"
                    +"VAWKUMSATZ= :VAWKUMSATZ,"
                    +"VAWKMENGE= :VAWKMENGE,"
                    +"VAWKPREIS= :VAWKPREIS,"
                    +"VAWKHK= :VAWKHK,"
                    +"VAWTHK= :VAWTHK,"
                    +"VAWHKTAB1= :VAWHKTAB1,"
                    +"VAWHKTAB2= :VAWHKTAB2,"
                    +"VAWHKTAB3= :VAWHKTAB3,"
                    +"VAWHKTAB4= :VAWHKTAB4,"
                    +"VAWHKTAB5= :VAWHKTAB5,"
                    +"VAWHKTAB6= :VAWHKTAB6,"
                    +"VAWKDB= :VAWKDB,"
                    +"VAWTDB= :VAWTDB,"
                    +"VAWDBTAB1= :VAWDBTAB1,"
                    +"VAWDBTAB2= :VAWDBTAB2,"
                    +"VAWDBTAB3= :VAWDBTAB3,"
                    +"VAWDBTAB4= :VAWDBTAB4,"
                    +"VAWDBTAB5= :VAWDBTAB5,"
                    +"VAWDBTAB6= :VAWDBTAB6,"
                    +"VAWKVPROV= :VAWKVPROV,"
                    +"VAWTVPROV= :VAWTVPROV,"
                    +"VAWKFRACHT= :VAWKFRACHT,"
                    +"VAWTFRACHT= :VAWTFRACHT,"
                    +"VAWKVERP= :VAWKVERP,"
                    +"VAWTVERP= :VAWTVERP,"
                    +"VAWKRABATT= :VAWKRABATT,"
                    +"VAWTRABATT= :VAWTRABATT,"
                    +"VAWKVERSICH= :VAWKVERSICH,"
                    +"VAWTVERSICH= :VAWTVERSICH,"
                    +"VAWKZUAB= :VAWKZUAB,"
                    +"VAWTZUAB= :VAWTZUAB,"
                    +"VAWAUFBER= :VAWAUFBER,"
                    +"VAWRANKING= :VAWRANKING,"
                    +"VAWABSART= :VAWABSART,"
                    +"VAWRGRQM= :VAWRGRQM,"
                    +"VAWFGRQM= :VAWFGRQM,"
                    +"VAWRFDDIS= :VAWRFDDIS,"
                    +"VAWKVB= :VAWKVB,"
                    +"VAWVBV= :VAWVBV,"
                    +"VAWVBB= :VAWVBB,"
                    +"VAWSVB= :VAWSVB,"
                    +"VAWVVB= :VAWVVB,"
                    +"VAWKVG= :VAWKVG,"
                    +"VAWVGV= :VAWVGV,"
                    +"VAWVGB= :VAWVGB,"
                    +"VAWSVG= :VAWSVG,"
                    +"VAWVVG= :VAWVVG,"
                    +"VAWKVERTNR= :VAWKVERTNR,"
                    +"VAWVERTNRV= :VAWVERTNRV,"
                    +"VAWVERTNRB= :VAWVERTNRB,"
                    +"VAWSVERTNR= :VAWSVERTNR,"
                    +"VAWVVERTNR= :VAWVVERTNR,"
                    +"VAWKPROJNR= :VAWKPROJNR,"
                    +"VAWPROJNR= :VAWPROJNR,"
                    +"VAWSPROJNR= :VAWSPROJNR,"
                    +"VAWVPROJNR= :VAWVPROJNR,"
                    +"VAWKKZINLEXP= :VAWKKZINLEXP,"
                    +"VAWKZINLEXP= :VAWKZINLEXP,"
                    +"VAWSINLEXP= :VAWSINLEXP,"
                    +"VAWVINLEXP= :VAWVINLEXP,"
                    +"VAWKLAND= :VAWKLAND,"
                    +"VAWLAND= :VAWLAND,"
                    +"VAWSLAND= :VAWSLAND,"
                    +"VAWVLAND= :VAWVLAND,"
                    +"VAWKWR= :VAWKWR,"
                    +"VAWWR= :VAWWR,"
                    +"VAWSWR= :VAWSWR,"
                    +"VAWVWR= :VAWVWR,"
                    +"VAWKGEBIET= :VAWKGEBIET,"
                    +"VAWGEBIET= :VAWGEBIET,"
                    +"VAWSGEBIET= :VAWSGEBIET,"
                    +"VAWVGEBIET= :VAWVGEBIET,"
                    +"VAWKPLZ= :VAWKPLZ,"
                    +"VAWPLZV= :VAWPLZV,"
                    +"VAWPLZB= :VAWPLZB,"
                    +"VAWSPLZ= :VAWSPLZ,"
                    +"VAWVPLZ= :VAWVPLZ,"
                    +"VAWKCOUNTY= :VAWKCOUNTY,"
                    +"VAWCOUNTYV= :VAWCOUNTYV,"
                    +"VAWCOUNTYB= :VAWCOUNTYB,"
                    +"VAWSCOUNTY= :VAWSCOUNTY,"
                    +"VAWVCOUNTY= :VAWVCOUNTY,"
                    +"VAWKCITY= :VAWKCITY,"
                    +"VAWCITYV= :VAWCITYV,"
                    +"VAWCITYB= :VAWCITYB,"
                    +"VAWSCITY= :VAWSCITY,"
                    +"VAWVCITY= :VAWVCITY,"
                    +"VAWKABNGRP= :VAWKABNGRP,"
                    +"VAWABNGRP= :VAWABNGRP,"
                    +"VAWSABNGRP= :VAWSABNGRP,"
                    +"VAWVABNGRP= :VAWVABNGRP,"
                    +"VAWKABNGST= :VAWKABNGST,"
                    +"VAWABNGRPST= :VAWABNGRPST,"
                    +"VAWSABNGST= :VAWSABNGST,"
                    +"VAWVABNGST= :VAWVABNGST,"
                    +"VAWKVERBNR= :VAWKVERBNR,"
                    +"VAWZENTRRV= :VAWZENTRRV,"
                    +"VAWVERBNR= :VAWVERBNR,"
                    +"VAWSVERBNR= :VAWSVERBNR,"
                    +"VAWVVERBNR= :VAWVVERBNR,"
                    +"VAWKZENTR= :VAWKZENTR,"
                    +"VAWZENTRRZ= :VAWZENTRRZ,"
                    +"VAWZENTR= :VAWZENTR,"
                    +"VAWSZENTR= :VAWSZENTR,"
                    +"VAWVZENTR= :VAWVZENTR,"
                    +"VAWKKUNDST= :VAWKKUNDST,"
                    +"VAWKUNDNRST= :VAWKUNDNRST,"
                    +"VAWSKUNDST= :VAWSKUNDST,"
                    +"VAWVKUNDST= :VAWVKUNDST,"
                    +"VAWKSACHBE= :VAWKSACHBE,"
                    +"VAWSACHBE= :VAWSACHBE,"
                    +"VAWSSACHBE= :VAWSSACHBE,"
                    +"VAWVSACHBE= :VAWVSACHBE,"
                    +"VAWKKUNDNR= :VAWKKUNDNR,"
                    +"VAWKUNDNR= :VAWKUNDNR,"
                    +"VAWSKUNDNR= :VAWSKUNDNR,"
                    +"VAWVKUNDNR= :VAWVKUNDNR,"
                    +"VAWKBRANCHE= :VAWKBRANCHE,"
                    +"VAWBRANCHE= :VAWBRANCHE,"
                    +"VAWSBRANCHE= :VAWSBRANCHE,"
                    +"VAWVBRANCHE= :VAWVBRANCHE,"
                    +"VAWKABCKL= :VAWKABCKL,"
                    +"VAWABCKL1= :VAWABCKL1,"
                    +"VAWABCKL2= :VAWABCKL2,"
                    +"VAWABCKL3= :VAWABCKL3,"
                    +"VAWSABCKL= :VAWSABCKL,"
                    +"VAWVABCKL= :VAWVABCKL,"
                    +"VAWKPOSTYP= :VAWKPOSTYP,"
                    +"VAWPOSTYP= :VAWPOSTYP,"
                    +"VAWSPOSTYP= :VAWSPOSTYP,"
                    +"VAWVPOSTYP= :VAWVPOSTYP,"
                    +"VAWKCOUPON= :VAWKCOUPON,"
                    +"VAWCOUPON= :VAWCOUPON,"
                    +"VAWSCOUPON= :VAWSCOUPON,"
                    +"VAWVCOUPON= :VAWVCOUPON,"
                    +"VAWKORDER= :VAWKORDER,"
                    +"VAWORDER= :VAWORDER,"
                    +"VAWSORDER= :VAWSORDER,"
                    +"VAWVORDER= :VAWVORDER,"
                    +"VAWKPRGRP= :VAWKPRGRP,"
                    +"VAWPRGRP= :VAWPRGRP,"
                    +"VAWSPRGRP= :VAWSPRGRP,"
                    +"VAWVPRGRP= :VAWVPRGRP,"
                    +"VAWKGRUND= :VAWKGRUND,"
                    +"VAWGRUNDV= :VAWGRUNDV,"
                    +"VAWGRUNDB= :VAWGRUNDB,"
                    +"VAWSGRUND= :VAWSGRUND,"
                    +"VAWVGRUND= :VAWVGRUND,"
                    +"VAWKPRDGR= :VAWKPRDGR,"
                    +"VAWPRDGR= :VAWPRDGR,"
                    +"VAWSPRDGR= :VAWSPRDGR,"
                    +"VAWVPRDGR= :VAWVPRDGR,"
                    +"VAWKARTGRP= :VAWKARTGRP,"
                    +"VAWARTGRP= :VAWARTGRP,"
                    +"VAWSARTGRP= :VAWSARTGRP,"
                    +"VAWVARTGRP= :VAWVARTGRP,"
                    +"VAWKZIELGR= :VAWKZIELGR,"
                    +"VAWZIELGR= :VAWZIELGR,"
                    +"VAWSZIELGR= :VAWSZIELGR,"
                    +"VAWVZIELGR= :VAWVZIELGR,"
                    +"VAWKOBERKOLL= :VAWKOBERKOLL,"
                    +"VAWOBERKOLL= :VAWOBERKOLL,"
                    +"VAWSOBERKOLL= :VAWSOBERKOLL,"
                    +"VAWVOBERKOLL= :VAWVOBERKOLL,"
                    +"VAWKKOLL= :VAWKKOLL,"
                    +"VAWKOLL= :VAWKOLL,"
                    +"VAWSKOLL= :VAWSKOLL,"
                    +"VAWVKOLL= :VAWVKOLL,"
                    +"VAWKVART= :VAWKVART,"
                    +"VAWVART= :VAWVART,"
                    +"VAWSVART= :VAWSVART,"
                    +"VAWVVART= :VAWVVART,"
                    +"VAWKVFARBE= :VAWKVFARBE,"
                    +"VAWVFARBEV= :VAWVFARBEV,"
                    +"VAWVFARBEB= :VAWVFARBEB,"
                    +"VAWSVFARBE= :VAWSVFARBE,"
                    +"VAWVVFARBE= :VAWVVFARBE,"
                    +"VAWKGROE= :VAWKGROE,"
                    +"VAWGROE= :VAWGROE,"
                    +"VAWSGROE= :VAWSGROE,"
                    +"VAWVGROE= :VAWVGROE,"
                    +"VAWKVZENSUR= :VAWKVZENSUR,"
                    +"VAWVZENSURV= :VAWVZENSURV,"
                    +"VAWVZENSURB= :VAWVZENSURB,"
                    +"VAWSVZENSUR= :VAWSVZENSUR,"
                    +"VAWVVZENSUR= :VAWVVZENSUR,"
                    +"VAWKVAUFMART= :VAWKVAUFMART,"
                    +"VAWVAUFMART= :VAWVAUFMART,"
                    +"VAWSVAUFMART= :VAWSVAUFMART,"
                    +"VAWVVAUFMART= :VAWVVAUFMART,"
                    +"VAWKVERPSL= :VAWKVERPSL,"
                    +"VAWVERPSL= :VAWVERPSL,"
                    +"VAWSVERPSL= :VAWSVERPSL,"
                    +"VAWVVERPSL= :VAWVVERPSL,"
                    +"VAWKLIEFSG= :VAWKLIEFSG,"
                    +"VAWLIEFSG= :VAWLIEFSG,"
                    +"VAWSLIEFSG= :VAWSLIEFSG,"
                    +"VAWVLIEFSG= :VAWVLIEFSG,"
                    +"VAWKWRKABT= :VAWKWRKABT,"
                    +"VAWWERK= :VAWWERK,"
                    +"VAWABT= :VAWABT,"
                    +"VAWSWRKABT= :VAWSWRKABT,"
                    +"VAWVWRKABT= :VAWVWRKABT,"
                    +"VAWKDART= :VAWKDART,"
                    +"VAWDART= :VAWDART,"
                    +"VAWDVAR= :VAWDVAR,"
                    +"VAWSDART= :VAWSDART,"
                    +"VAWVDART= :VAWVDART,"
                    +"VAWKPART= :VAWKPART,"
                    +"VAWPWAKZ= :VAWPWAKZ,"
                    +"VAWPART= :VAWPART,"
                    +"VAWPVAR= :VAWPVAR,"
                    +"VAWSPART= :VAWSPART,"
                    +"VAWVPART= :VAWVPART,"
                    +"VAWKPLART= :VAWKPLART,"
                    +"VAWPLART= :VAWPLART,"
                    +"VAWSPLART= :VAWSPLART,"
                    +"VAWVPLART= :VAWVPLART,"
                    +"VAWKFFARBE= :VAWKFFARBE,"
                    +"VAWFFARBE= :VAWFFARBE,"
                    +"VAWSFFARBE= :VAWSFFARBE,"
                    +"VAWVFFARBE= :VAWVFFARBE,"
                    +"VAWKDESS= :VAWKDESS,"
                    +"VAWDESS= :VAWDESS,"
                    +"VAWSDESS= :VAWSDESS,"
                    +"VAWVDESS= :VAWVDESS,"
                    +"VAWKCOLORIT= :VAWKCOLORIT,"
                    +"VAWCOLORIT= :VAWCOLORIT,"
                    +"VAWSCOLORIT= :VAWSCOLORIT,"
                    +"VAWVCOLORIT= :VAWVCOLORIT,"
                    +"VAWKBESCHICH= :VAWKBESCHICH,"
                    +"VAWBESCHICH= :VAWBESCHICH,"
                    +"VAWSBESCHICH= :VAWSBESCHICH,"
                    +"VAWVBESCHICH= :VAWVBESCHICH,"
                    +"VAWVONST= :VAWVONST,"
                    +"VAWANZST= :VAWANZST,"
                    +"VAWKUMSATZ4= :VAWKUMSATZ4,"
                    +"VAWUMSATZV= :VAWUMSATZV,"
                    +"VAWUMSATZB= :VAWUMSATZB,"
                    +"VAWSUMSATZ= :VAWSUMSATZ,"
                    +"VAWVUMSATZ= :VAWVUMSATZ,"
                    +"VAWKDB4= :VAWKDB4,"
                    +"VAWINDEX= :VAWINDEX,"
                    +"VAWDBV= :VAWDBV,"
                    +"VAWDBB= :VAWDBB,"
                    +"VAWSDB4= :VAWSDB4,"
                    +"VAWVDB4= :VAWVDB4,"
                    +"VAWKLITERM= :VAWKLITERM,"
                    +"VAWLITERMV= :VAWLITERMV,"
                    +"VAWLITERMB= :VAWLITERMB,"
                    +"VAWSLITERM= :VAWSLITERM,"
                    +"VAWVLITERM= :VAWVLITERM,"
                    +"VAWKAUFTR= :VAWKAUFTR,"
                    +"VAWAUFKRS= :VAWAUFKRS,"
                    +"VAWAUFLFD= :VAWAUFLFD,"
                    +"VAWAUFPOS= :VAWAUFPOS,"
                    +"VAWSAUFTR= :VAWSAUFTR,"
                    +"VAWVAUFTR= :VAWVAUFTR,"
                    +"VAWKRECH= :VAWKRECH,"
                    +"VAWRENR= :VAWRENR,"
                    +"VAWREPOS= :VAWREPOS,"
                    +"VAWREDAT= :VAWREDAT,"
                    +"VAWSRECH= :VAWSRECH,"
                    +"VAWVRECH= :VAWVRECH,"
                    +"VAWKVZOLLTNR= :VAWKVZOLLTNR,"
                    +"VAWVZOLLTNR= :VAWVZOLLTNR,"
                    +"VAWSVZOLLTNR= :VAWSVZOLLTNR,"
                    +"VAWVVZOLLTNR= :VAWVVZOLLTNR,"
                    +"VAWKSTATWNR= :VAWKSTATWNR,"
                    +"VAWSTATWNR= :VAWSTATWNR,"
                    +"VAWSSTATWNR= :VAWSSTATWNR,"
                    +"VAWVSTATWNR= :VAWVSTATWNR,"
                    +"VAWKBUSIMODE= :VAWKBUSIMODE,"
                    +"VAWBUSIMODE= :VAWBUSIMODE,"
                    +"VAWSBUSIMODE= :VAWSBUSIMODE,"
                    +"VAWVBUSIMODE= :VAWVBUSIMODE,"
                    +"VAWKTITER= :VAWKTITER,"
                    +"VAWNUMART= :VAWNUMART,"
                    +"VAWGARNNR1= :VAWGARNNR1,"
                    +"VAWGARNNR2= :VAWGARNNR2,"
                    +"VAWSTITER= :VAWSTITER,"
                    +"VAWVTITER= :VAWVTITER,"
                    +"VAWKURSPPART= :VAWKURSPPART,"
                    +"VAWURSPPART= :VAWURSPPART,"
                    +"VAWSURSPPART= :VAWSURSPPART,"
                    +"VAWVURSPPART= :VAWVURSPPART,"
                    +"VAWKSPPART= :VAWKSPPART,"
                    +"VAWSPPART= :VAWSPPART,"
                    +"VAWSSPPART= :VAWSSPPART,"
                    +"VAWVSPPART= :VAWVSPPART,"
                    +"VAWKKUNDNRKO= :VAWKKUNDNRKO,"
                    +"VAWKUNDNRKO= :VAWKUNDNRKO,"
                    +"VAWSKUNDNRKO= :VAWSKUNDNRKO,"
                    +"VAWVKUNDNRKO= :VAWVKUNDNRKO,"
                    +"VAWKFARBGRP= :VAWKFARBGRP,"
                    +"VAWFARBGRP= :VAWFARBGRP,"
                    +"VAWSFARBGRP= :VAWSFARBGRP,"
                    +"VAWVFARBGRP= :VAWVFARBGRP,"
                    +"VAWKKDKOLL= :VAWKKDKOLL,"
                    +"VAWKDKOLL= :VAWKDKOLL,"
                    +"VAWSKDKOLL= :VAWSKDKOLL,"
                    +"VAWVKDKOLL= :VAWVKDKOLL,"
                    +"VAWKMKOLL= :VAWKMKOLL,"
                    +"VAWMKOLL= :VAWMKOLL,"
                    +"VAWSMKOLL= :VAWSMKOLL,"
                    +"VAWVMKOLL= :VAWVMKOLL,"
                    +"VAWFILLER2= :VAWFILLER2,"
                    +"VAWSEITE= :VAWSEITE,"
                    +"VAWKUNDKZ= :VAWKUNDKZ,"
                    +"VAWVARTKZ= :VAWVARTKZ,"
                    +"VAWUMSATZKZ= :VAWUMSATZKZ,"
                    +"VAWKZKUNDE= :VAWKZKUNDE,"
                    +"VAWMATKOMP= :VAWMATKOMP,"
                    +"VAWKMORD= :VAWKMORD,"
                    +"VAWSMORD= :VAWSMORD,"
                    +"VAWVMORD= :VAWVMORD,"
                    +"VAWFILLER= :VAWFILLER,"
                    +"VAWAENZL= :VAWAENZL,"
                    +"VAWAENB= :VAWAENB,"
                    +"VAWAEND= :VAWAEND,"
                    +"VAWNEUB= :VAWNEUB,"
                    +"VAWNEUD= :VAWNEUD,"
                        + " WHERE  "
                        + "  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                    #endregion

                    #region====Parameters====
          or1.Parameters.Add("VAWMANDANT", OracleType.NVarChar).Value = dwData["VAWMANDANT"].ToString(); 
          or1.Parameters.Add("VAWSL", OracleType.NVarChar).Value = dwData["VAWSL"].ToString(); 
          or1.Parameters.Add("VAWTITEL", OracleType.NVarChar).Value = dwData["VAWTITEL"].ToString(); 
          or1.Parameters.Add("VAWSUMMEN", OracleType.NVarChar).Value = dwData["VAWSUMMEN"].ToString(); 
          or1.Parameters.Add("VAWABW", OracleType.NVarChar).Value = dwData["VAWABW"].ToString(); 
          or1.Parameters.Add("VAWZEITRAUM", OracleType.NVarChar).Value = dwData["VAWZEITRAUM"].ToString(); 
          or1.Parameters.Add("VAWUMSATZ", OracleType.NVarChar).Value = dwData["VAWUMSATZ"].ToString(); 
          or1.Parameters.Add("VAWMEEH", OracleType.NVarChar).Value = dwData["VAWMEEH"].ToString(); 
          or1.Parameters.Add("VAWMEEHGRP", OracleType.NVarChar).Value = dwData["VAWMEEHGRP"].ToString(); 
          or1.Parameters.Add("VAWMEEHFKT", OracleType.NVarChar).Value = dwData["VAWMEEHFKT"].ToString(); 
          or1.Parameters.Add("VAWPREH", OracleType.NVarChar).Value = dwData["VAWPREH"].ToString(); 
          or1.Parameters.Add("VAWPREHGRP", OracleType.NVarChar).Value = dwData["VAWPREHGRP"].ToString(); 
          or1.Parameters.Add("VAWPREHFKT", OracleType.NVarChar).Value = dwData["VAWPREHFKT"].ToString(); 
          or1.Parameters.Add("VAWSTTYP", OracleType.NVarChar).Value = dwData["VAWSTTYP"].ToString(); 
          or1.Parameters.Add("VAWKUMSATZ", OracleType.NVarChar).Value = dwData["VAWKUMSATZ"].ToString(); 
          or1.Parameters.Add("VAWKMENGE", OracleType.NVarChar).Value = dwData["VAWKMENGE"].ToString(); 
          or1.Parameters.Add("VAWKPREIS", OracleType.NVarChar).Value = dwData["VAWKPREIS"].ToString(); 
          or1.Parameters.Add("VAWKHK", OracleType.NVarChar).Value = dwData["VAWKHK"].ToString(); 
          or1.Parameters.Add("VAWTHK", OracleType.NVarChar).Value = dwData["VAWTHK"].ToString(); 
          or1.Parameters.Add("VAWHKTAB1", OracleType.NVarChar).Value = dwData["VAWHKTAB1"].ToString(); 
          or1.Parameters.Add("VAWHKTAB2", OracleType.NVarChar).Value = dwData["VAWHKTAB2"].ToString(); 
          or1.Parameters.Add("VAWHKTAB3", OracleType.NVarChar).Value = dwData["VAWHKTAB3"].ToString(); 
          or1.Parameters.Add("VAWHKTAB4", OracleType.NVarChar).Value = dwData["VAWHKTAB4"].ToString(); 
          or1.Parameters.Add("VAWHKTAB5", OracleType.NVarChar).Value = dwData["VAWHKTAB5"].ToString(); 
          or1.Parameters.Add("VAWHKTAB6", OracleType.NVarChar).Value = dwData["VAWHKTAB6"].ToString(); 
          or1.Parameters.Add("VAWKDB", OracleType.NVarChar).Value = dwData["VAWKDB"].ToString(); 
          or1.Parameters.Add("VAWTDB", OracleType.NVarChar).Value = dwData["VAWTDB"].ToString(); 
          or1.Parameters.Add("VAWDBTAB1", OracleType.NVarChar).Value = dwData["VAWDBTAB1"].ToString(); 
          or1.Parameters.Add("VAWDBTAB2", OracleType.NVarChar).Value = dwData["VAWDBTAB2"].ToString(); 
          or1.Parameters.Add("VAWDBTAB3", OracleType.NVarChar).Value = dwData["VAWDBTAB3"].ToString(); 
          or1.Parameters.Add("VAWDBTAB4", OracleType.NVarChar).Value = dwData["VAWDBTAB4"].ToString(); 
          or1.Parameters.Add("VAWDBTAB5", OracleType.NVarChar).Value = dwData["VAWDBTAB5"].ToString(); 
          or1.Parameters.Add("VAWDBTAB6", OracleType.NVarChar).Value = dwData["VAWDBTAB6"].ToString(); 
          or1.Parameters.Add("VAWKVPROV", OracleType.NVarChar).Value = dwData["VAWKVPROV"].ToString(); 
          or1.Parameters.Add("VAWTVPROV", OracleType.NVarChar).Value = dwData["VAWTVPROV"].ToString(); 
          or1.Parameters.Add("VAWKFRACHT", OracleType.NVarChar).Value = dwData["VAWKFRACHT"].ToString(); 
          or1.Parameters.Add("VAWTFRACHT", OracleType.NVarChar).Value = dwData["VAWTFRACHT"].ToString(); 
          or1.Parameters.Add("VAWKVERP", OracleType.NVarChar).Value = dwData["VAWKVERP"].ToString(); 
          or1.Parameters.Add("VAWTVERP", OracleType.NVarChar).Value = dwData["VAWTVERP"].ToString(); 
          or1.Parameters.Add("VAWKRABATT", OracleType.NVarChar).Value = dwData["VAWKRABATT"].ToString(); 
          or1.Parameters.Add("VAWTRABATT", OracleType.NVarChar).Value = dwData["VAWTRABATT"].ToString(); 
          or1.Parameters.Add("VAWKVERSICH", OracleType.NVarChar).Value = dwData["VAWKVERSICH"].ToString(); 
          or1.Parameters.Add("VAWTVERSICH", OracleType.NVarChar).Value = dwData["VAWTVERSICH"].ToString(); 
          or1.Parameters.Add("VAWKZUAB", OracleType.NVarChar).Value = dwData["VAWKZUAB"].ToString(); 
          or1.Parameters.Add("VAWTZUAB", OracleType.NVarChar).Value = dwData["VAWTZUAB"].ToString(); 
          or1.Parameters.Add("VAWAUFBER", OracleType.NVarChar).Value = dwData["VAWAUFBER"].ToString(); 
          or1.Parameters.Add("VAWRANKING", OracleType.NVarChar).Value = dwData["VAWRANKING"].ToString(); 
          or1.Parameters.Add("VAWABSART", OracleType.NVarChar).Value = dwData["VAWABSART"].ToString(); 
          or1.Parameters.Add("VAWRGRQM", OracleType.NVarChar).Value = dwData["VAWRGRQM"].ToString(); 
          or1.Parameters.Add("VAWFGRQM", OracleType.NVarChar).Value = dwData["VAWFGRQM"].ToString(); 
          or1.Parameters.Add("VAWRFDDIS", OracleType.NVarChar).Value = dwData["VAWRFDDIS"].ToString(); 
          or1.Parameters.Add("VAWKVB", OracleType.NVarChar).Value = dwData["VAWKVB"].ToString(); 
          or1.Parameters.Add("VAWVBV", OracleType.NVarChar).Value = dwData["VAWVBV"].ToString(); 
          or1.Parameters.Add("VAWVBB", OracleType.NVarChar).Value = dwData["VAWVBB"].ToString(); 
          or1.Parameters.Add("VAWSVB", OracleType.NVarChar).Value = dwData["VAWSVB"].ToString(); 
          or1.Parameters.Add("VAWVVB", OracleType.NVarChar).Value = dwData["VAWVVB"].ToString(); 
          or1.Parameters.Add("VAWKVG", OracleType.NVarChar).Value = dwData["VAWKVG"].ToString(); 
          or1.Parameters.Add("VAWVGV", OracleType.NVarChar).Value = dwData["VAWVGV"].ToString(); 
          or1.Parameters.Add("VAWVGB", OracleType.NVarChar).Value = dwData["VAWVGB"].ToString(); 
          or1.Parameters.Add("VAWSVG", OracleType.NVarChar).Value = dwData["VAWSVG"].ToString(); 
          or1.Parameters.Add("VAWVVG", OracleType.NVarChar).Value = dwData["VAWVVG"].ToString(); 
          or1.Parameters.Add("VAWKVERTNR", OracleType.NVarChar).Value = dwData["VAWKVERTNR"].ToString(); 
          or1.Parameters.Add("VAWVERTNRV", OracleType.NVarChar).Value = dwData["VAWVERTNRV"].ToString(); 
          or1.Parameters.Add("VAWVERTNRB", OracleType.NVarChar).Value = dwData["VAWVERTNRB"].ToString(); 
          or1.Parameters.Add("VAWSVERTNR", OracleType.NVarChar).Value = dwData["VAWSVERTNR"].ToString(); 
          or1.Parameters.Add("VAWVVERTNR", OracleType.NVarChar).Value = dwData["VAWVVERTNR"].ToString(); 
          or1.Parameters.Add("VAWKPROJNR", OracleType.NVarChar).Value = dwData["VAWKPROJNR"].ToString(); 
          or1.Parameters.Add("VAWPROJNR", OracleType.NVarChar).Value = dwData["VAWPROJNR"].ToString(); 
          or1.Parameters.Add("VAWSPROJNR", OracleType.NVarChar).Value = dwData["VAWSPROJNR"].ToString(); 
          or1.Parameters.Add("VAWVPROJNR", OracleType.NVarChar).Value = dwData["VAWVPROJNR"].ToString(); 
          or1.Parameters.Add("VAWKKZINLEXP", OracleType.NVarChar).Value = dwData["VAWKKZINLEXP"].ToString(); 
          or1.Parameters.Add("VAWKZINLEXP", OracleType.NVarChar).Value = dwData["VAWKZINLEXP"].ToString(); 
          or1.Parameters.Add("VAWSINLEXP", OracleType.NVarChar).Value = dwData["VAWSINLEXP"].ToString(); 
          or1.Parameters.Add("VAWVINLEXP", OracleType.NVarChar).Value = dwData["VAWVINLEXP"].ToString(); 
          or1.Parameters.Add("VAWKLAND", OracleType.NVarChar).Value = dwData["VAWKLAND"].ToString(); 
          or1.Parameters.Add("VAWLAND", OracleType.NVarChar).Value = dwData["VAWLAND"].ToString(); 
          or1.Parameters.Add("VAWSLAND", OracleType.NVarChar).Value = dwData["VAWSLAND"].ToString(); 
          or1.Parameters.Add("VAWVLAND", OracleType.NVarChar).Value = dwData["VAWVLAND"].ToString(); 
          or1.Parameters.Add("VAWKWR", OracleType.NVarChar).Value = dwData["VAWKWR"].ToString(); 
          or1.Parameters.Add("VAWWR", OracleType.NVarChar).Value = dwData["VAWWR"].ToString(); 
          or1.Parameters.Add("VAWSWR", OracleType.NVarChar).Value = dwData["VAWSWR"].ToString(); 
          or1.Parameters.Add("VAWVWR", OracleType.NVarChar).Value = dwData["VAWVWR"].ToString(); 
          or1.Parameters.Add("VAWKGEBIET", OracleType.NVarChar).Value = dwData["VAWKGEBIET"].ToString(); 
          or1.Parameters.Add("VAWGEBIET", OracleType.NVarChar).Value = dwData["VAWGEBIET"].ToString(); 
          or1.Parameters.Add("VAWSGEBIET", OracleType.NVarChar).Value = dwData["VAWSGEBIET"].ToString(); 
          or1.Parameters.Add("VAWVGEBIET", OracleType.NVarChar).Value = dwData["VAWVGEBIET"].ToString(); 
          or1.Parameters.Add("VAWKPLZ", OracleType.NVarChar).Value = dwData["VAWKPLZ"].ToString(); 
          or1.Parameters.Add("VAWPLZV", OracleType.NVarChar).Value = dwData["VAWPLZV"].ToString(); 
          or1.Parameters.Add("VAWPLZB", OracleType.NVarChar).Value = dwData["VAWPLZB"].ToString(); 
          or1.Parameters.Add("VAWSPLZ", OracleType.NVarChar).Value = dwData["VAWSPLZ"].ToString(); 
          or1.Parameters.Add("VAWVPLZ", OracleType.NVarChar).Value = dwData["VAWVPLZ"].ToString(); 
          or1.Parameters.Add("VAWKCOUNTY", OracleType.NVarChar).Value = dwData["VAWKCOUNTY"].ToString(); 
          or1.Parameters.Add("VAWCOUNTYV", OracleType.NVarChar).Value = dwData["VAWCOUNTYV"].ToString(); 
          or1.Parameters.Add("VAWCOUNTYB", OracleType.NVarChar).Value = dwData["VAWCOUNTYB"].ToString(); 
          or1.Parameters.Add("VAWSCOUNTY", OracleType.NVarChar).Value = dwData["VAWSCOUNTY"].ToString(); 
          or1.Parameters.Add("VAWVCOUNTY", OracleType.NVarChar).Value = dwData["VAWVCOUNTY"].ToString(); 
          or1.Parameters.Add("VAWKCITY", OracleType.NVarChar).Value = dwData["VAWKCITY"].ToString(); 
          or1.Parameters.Add("VAWCITYV", OracleType.NVarChar).Value = dwData["VAWCITYV"].ToString(); 
          or1.Parameters.Add("VAWCITYB", OracleType.NVarChar).Value = dwData["VAWCITYB"].ToString(); 
          or1.Parameters.Add("VAWSCITY", OracleType.NVarChar).Value = dwData["VAWSCITY"].ToString(); 
          or1.Parameters.Add("VAWVCITY", OracleType.NVarChar).Value = dwData["VAWVCITY"].ToString(); 
          or1.Parameters.Add("VAWKABNGRP", OracleType.NVarChar).Value = dwData["VAWKABNGRP"].ToString(); 
          or1.Parameters.Add("VAWABNGRP", OracleType.NVarChar).Value = dwData["VAWABNGRP"].ToString(); 
          or1.Parameters.Add("VAWSABNGRP", OracleType.NVarChar).Value = dwData["VAWSABNGRP"].ToString(); 
          or1.Parameters.Add("VAWVABNGRP", OracleType.NVarChar).Value = dwData["VAWVABNGRP"].ToString(); 
          or1.Parameters.Add("VAWKABNGST", OracleType.NVarChar).Value = dwData["VAWKABNGST"].ToString(); 
          or1.Parameters.Add("VAWABNGRPST", OracleType.NVarChar).Value = dwData["VAWABNGRPST"].ToString(); 
          or1.Parameters.Add("VAWSABNGST", OracleType.NVarChar).Value = dwData["VAWSABNGST"].ToString(); 
          or1.Parameters.Add("VAWVABNGST", OracleType.NVarChar).Value = dwData["VAWVABNGST"].ToString(); 
          or1.Parameters.Add("VAWKVERBNR", OracleType.NVarChar).Value = dwData["VAWKVERBNR"].ToString(); 
          or1.Parameters.Add("VAWZENTRRV", OracleType.NVarChar).Value = dwData["VAWZENTRRV"].ToString(); 
          or1.Parameters.Add("VAWVERBNR", OracleType.NVarChar).Value = dwData["VAWVERBNR"].ToString(); 
          or1.Parameters.Add("VAWSVERBNR", OracleType.NVarChar).Value = dwData["VAWSVERBNR"].ToString(); 
          or1.Parameters.Add("VAWVVERBNR", OracleType.NVarChar).Value = dwData["VAWVVERBNR"].ToString(); 
          or1.Parameters.Add("VAWKZENTR", OracleType.NVarChar).Value = dwData["VAWKZENTR"].ToString(); 
          or1.Parameters.Add("VAWZENTRRZ", OracleType.NVarChar).Value = dwData["VAWZENTRRZ"].ToString(); 
          or1.Parameters.Add("VAWZENTR", OracleType.NVarChar).Value = dwData["VAWZENTR"].ToString(); 
          or1.Parameters.Add("VAWSZENTR", OracleType.NVarChar).Value = dwData["VAWSZENTR"].ToString(); 
          or1.Parameters.Add("VAWVZENTR", OracleType.NVarChar).Value = dwData["VAWVZENTR"].ToString(); 
          or1.Parameters.Add("VAWKKUNDST", OracleType.NVarChar).Value = dwData["VAWKKUNDST"].ToString(); 
          or1.Parameters.Add("VAWKUNDNRST", OracleType.NVarChar).Value = dwData["VAWKUNDNRST"].ToString(); 
          or1.Parameters.Add("VAWSKUNDST", OracleType.NVarChar).Value = dwData["VAWSKUNDST"].ToString(); 
          or1.Parameters.Add("VAWVKUNDST", OracleType.NVarChar).Value = dwData["VAWVKUNDST"].ToString(); 
          or1.Parameters.Add("VAWKSACHBE", OracleType.NVarChar).Value = dwData["VAWKSACHBE"].ToString(); 
          or1.Parameters.Add("VAWSACHBE", OracleType.NVarChar).Value = dwData["VAWSACHBE"].ToString(); 
          or1.Parameters.Add("VAWSSACHBE", OracleType.NVarChar).Value = dwData["VAWSSACHBE"].ToString(); 
          or1.Parameters.Add("VAWVSACHBE", OracleType.NVarChar).Value = dwData["VAWVSACHBE"].ToString(); 
          or1.Parameters.Add("VAWKKUNDNR", OracleType.NVarChar).Value = dwData["VAWKKUNDNR"].ToString(); 
          or1.Parameters.Add("VAWKUNDNR", OracleType.NVarChar).Value = dwData["VAWKUNDNR"].ToString(); 
          or1.Parameters.Add("VAWSKUNDNR", OracleType.NVarChar).Value = dwData["VAWSKUNDNR"].ToString(); 
          or1.Parameters.Add("VAWVKUNDNR", OracleType.NVarChar).Value = dwData["VAWVKUNDNR"].ToString(); 
          or1.Parameters.Add("VAWKBRANCHE", OracleType.NVarChar).Value = dwData["VAWKBRANCHE"].ToString(); 
          or1.Parameters.Add("VAWBRANCHE", OracleType.NVarChar).Value = dwData["VAWBRANCHE"].ToString(); 
          or1.Parameters.Add("VAWSBRANCHE", OracleType.NVarChar).Value = dwData["VAWSBRANCHE"].ToString(); 
          or1.Parameters.Add("VAWVBRANCHE", OracleType.NVarChar).Value = dwData["VAWVBRANCHE"].ToString(); 
          or1.Parameters.Add("VAWKABCKL", OracleType.NVarChar).Value = dwData["VAWKABCKL"].ToString(); 
          or1.Parameters.Add("VAWABCKL1", OracleType.NVarChar).Value = dwData["VAWABCKL1"].ToString(); 
          or1.Parameters.Add("VAWABCKL2", OracleType.NVarChar).Value = dwData["VAWABCKL2"].ToString(); 
          or1.Parameters.Add("VAWABCKL3", OracleType.NVarChar).Value = dwData["VAWABCKL3"].ToString(); 
          or1.Parameters.Add("VAWSABCKL", OracleType.NVarChar).Value = dwData["VAWSABCKL"].ToString(); 
          or1.Parameters.Add("VAWVABCKL", OracleType.NVarChar).Value = dwData["VAWVABCKL"].ToString(); 
          or1.Parameters.Add("VAWKPOSTYP", OracleType.NVarChar).Value = dwData["VAWKPOSTYP"].ToString(); 
          or1.Parameters.Add("VAWPOSTYP", OracleType.NVarChar).Value = dwData["VAWPOSTYP"].ToString(); 
          or1.Parameters.Add("VAWSPOSTYP", OracleType.NVarChar).Value = dwData["VAWSPOSTYP"].ToString(); 
          or1.Parameters.Add("VAWVPOSTYP", OracleType.NVarChar).Value = dwData["VAWVPOSTYP"].ToString(); 
          or1.Parameters.Add("VAWKCOUPON", OracleType.NVarChar).Value = dwData["VAWKCOUPON"].ToString(); 
          or1.Parameters.Add("VAWCOUPON", OracleType.NVarChar).Value = dwData["VAWCOUPON"].ToString(); 
          or1.Parameters.Add("VAWSCOUPON", OracleType.NVarChar).Value = dwData["VAWSCOUPON"].ToString(); 
          or1.Parameters.Add("VAWVCOUPON", OracleType.NVarChar).Value = dwData["VAWVCOUPON"].ToString(); 
          or1.Parameters.Add("VAWKORDER", OracleType.NVarChar).Value = dwData["VAWKORDER"].ToString(); 
          or1.Parameters.Add("VAWORDER", OracleType.NVarChar).Value = dwData["VAWORDER"].ToString(); 
          or1.Parameters.Add("VAWSORDER", OracleType.NVarChar).Value = dwData["VAWSORDER"].ToString(); 
          or1.Parameters.Add("VAWVORDER", OracleType.NVarChar).Value = dwData["VAWVORDER"].ToString(); 
          or1.Parameters.Add("VAWKPRGRP", OracleType.NVarChar).Value = dwData["VAWKPRGRP"].ToString(); 
          or1.Parameters.Add("VAWPRGRP", OracleType.NVarChar).Value = dwData["VAWPRGRP"].ToString(); 
          or1.Parameters.Add("VAWSPRGRP", OracleType.NVarChar).Value = dwData["VAWSPRGRP"].ToString(); 
          or1.Parameters.Add("VAWVPRGRP", OracleType.NVarChar).Value = dwData["VAWVPRGRP"].ToString(); 
          or1.Parameters.Add("VAWKGRUND", OracleType.NVarChar).Value = dwData["VAWKGRUND"].ToString(); 
          or1.Parameters.Add("VAWGRUNDV", OracleType.NVarChar).Value = dwData["VAWGRUNDV"].ToString(); 
          or1.Parameters.Add("VAWGRUNDB", OracleType.NVarChar).Value = dwData["VAWGRUNDB"].ToString(); 
          or1.Parameters.Add("VAWSGRUND", OracleType.NVarChar).Value = dwData["VAWSGRUND"].ToString(); 
          or1.Parameters.Add("VAWVGRUND", OracleType.NVarChar).Value = dwData["VAWVGRUND"].ToString(); 
          or1.Parameters.Add("VAWKPRDGR", OracleType.NVarChar).Value = dwData["VAWKPRDGR"].ToString(); 
          or1.Parameters.Add("VAWPRDGR", OracleType.NVarChar).Value = dwData["VAWPRDGR"].ToString(); 
          or1.Parameters.Add("VAWSPRDGR", OracleType.NVarChar).Value = dwData["VAWSPRDGR"].ToString(); 
          or1.Parameters.Add("VAWVPRDGR", OracleType.NVarChar).Value = dwData["VAWVPRDGR"].ToString(); 
          or1.Parameters.Add("VAWKARTGRP", OracleType.NVarChar).Value = dwData["VAWKARTGRP"].ToString(); 
          or1.Parameters.Add("VAWARTGRP", OracleType.NVarChar).Value = dwData["VAWARTGRP"].ToString(); 
          or1.Parameters.Add("VAWSARTGRP", OracleType.NVarChar).Value = dwData["VAWSARTGRP"].ToString(); 
          or1.Parameters.Add("VAWVARTGRP", OracleType.NVarChar).Value = dwData["VAWVARTGRP"].ToString(); 
          or1.Parameters.Add("VAWKZIELGR", OracleType.NVarChar).Value = dwData["VAWKZIELGR"].ToString(); 
          or1.Parameters.Add("VAWZIELGR", OracleType.NVarChar).Value = dwData["VAWZIELGR"].ToString(); 
          or1.Parameters.Add("VAWSZIELGR", OracleType.NVarChar).Value = dwData["VAWSZIELGR"].ToString(); 
          or1.Parameters.Add("VAWVZIELGR", OracleType.NVarChar).Value = dwData["VAWVZIELGR"].ToString(); 
          or1.Parameters.Add("VAWKOBERKOLL", OracleType.NVarChar).Value = dwData["VAWKOBERKOLL"].ToString(); 
          or1.Parameters.Add("VAWOBERKOLL", OracleType.NVarChar).Value = dwData["VAWOBERKOLL"].ToString(); 
          or1.Parameters.Add("VAWSOBERKOLL", OracleType.NVarChar).Value = dwData["VAWSOBERKOLL"].ToString(); 
          or1.Parameters.Add("VAWVOBERKOLL", OracleType.NVarChar).Value = dwData["VAWVOBERKOLL"].ToString(); 
          or1.Parameters.Add("VAWKKOLL", OracleType.NVarChar).Value = dwData["VAWKKOLL"].ToString(); 
          or1.Parameters.Add("VAWKOLL", OracleType.NVarChar).Value = dwData["VAWKOLL"].ToString(); 
          or1.Parameters.Add("VAWSKOLL", OracleType.NVarChar).Value = dwData["VAWSKOLL"].ToString(); 
          or1.Parameters.Add("VAWVKOLL", OracleType.NVarChar).Value = dwData["VAWVKOLL"].ToString(); 
          or1.Parameters.Add("VAWKVART", OracleType.NVarChar).Value = dwData["VAWKVART"].ToString(); 
          or1.Parameters.Add("VAWVART", OracleType.NVarChar).Value = dwData["VAWVART"].ToString(); 
          or1.Parameters.Add("VAWSVART", OracleType.NVarChar).Value = dwData["VAWSVART"].ToString(); 
          or1.Parameters.Add("VAWVVART", OracleType.NVarChar).Value = dwData["VAWVVART"].ToString(); 
          or1.Parameters.Add("VAWKVFARBE", OracleType.NVarChar).Value = dwData["VAWKVFARBE"].ToString(); 
          or1.Parameters.Add("VAWVFARBEV", OracleType.NVarChar).Value = dwData["VAWVFARBEV"].ToString(); 
          or1.Parameters.Add("VAWVFARBEB", OracleType.NVarChar).Value = dwData["VAWVFARBEB"].ToString(); 
          or1.Parameters.Add("VAWSVFARBE", OracleType.NVarChar).Value = dwData["VAWSVFARBE"].ToString(); 
          or1.Parameters.Add("VAWVVFARBE", OracleType.NVarChar).Value = dwData["VAWVVFARBE"].ToString(); 
          or1.Parameters.Add("VAWKGROE", OracleType.NVarChar).Value = dwData["VAWKGROE"].ToString(); 
          or1.Parameters.Add("VAWGROE", OracleType.NVarChar).Value = dwData["VAWGROE"].ToString(); 
          or1.Parameters.Add("VAWSGROE", OracleType.NVarChar).Value = dwData["VAWSGROE"].ToString(); 
          or1.Parameters.Add("VAWVGROE", OracleType.NVarChar).Value = dwData["VAWVGROE"].ToString(); 
          or1.Parameters.Add("VAWKVZENSUR", OracleType.NVarChar).Value = dwData["VAWKVZENSUR"].ToString(); 
          or1.Parameters.Add("VAWVZENSURV", OracleType.NVarChar).Value = dwData["VAWVZENSURV"].ToString(); 
          or1.Parameters.Add("VAWVZENSURB", OracleType.NVarChar).Value = dwData["VAWVZENSURB"].ToString(); 
          or1.Parameters.Add("VAWSVZENSUR", OracleType.NVarChar).Value = dwData["VAWSVZENSUR"].ToString(); 
          or1.Parameters.Add("VAWVVZENSUR", OracleType.NVarChar).Value = dwData["VAWVVZENSUR"].ToString(); 
          or1.Parameters.Add("VAWKVAUFMART", OracleType.NVarChar).Value = dwData["VAWKVAUFMART"].ToString(); 
          or1.Parameters.Add("VAWVAUFMART", OracleType.NVarChar).Value = dwData["VAWVAUFMART"].ToString(); 
          or1.Parameters.Add("VAWSVAUFMART", OracleType.NVarChar).Value = dwData["VAWSVAUFMART"].ToString(); 
          or1.Parameters.Add("VAWVVAUFMART", OracleType.NVarChar).Value = dwData["VAWVVAUFMART"].ToString(); 
          or1.Parameters.Add("VAWKVERPSL", OracleType.NVarChar).Value = dwData["VAWKVERPSL"].ToString(); 
          or1.Parameters.Add("VAWVERPSL", OracleType.NVarChar).Value = dwData["VAWVERPSL"].ToString(); 
          or1.Parameters.Add("VAWSVERPSL", OracleType.NVarChar).Value = dwData["VAWSVERPSL"].ToString(); 
          or1.Parameters.Add("VAWVVERPSL", OracleType.NVarChar).Value = dwData["VAWVVERPSL"].ToString(); 
          or1.Parameters.Add("VAWKLIEFSG", OracleType.NVarChar).Value = dwData["VAWKLIEFSG"].ToString(); 
          or1.Parameters.Add("VAWLIEFSG", OracleType.NVarChar).Value = dwData["VAWLIEFSG"].ToString(); 
          or1.Parameters.Add("VAWSLIEFSG", OracleType.NVarChar).Value = dwData["VAWSLIEFSG"].ToString(); 
          or1.Parameters.Add("VAWVLIEFSG", OracleType.NVarChar).Value = dwData["VAWVLIEFSG"].ToString(); 
          or1.Parameters.Add("VAWKWRKABT", OracleType.NVarChar).Value = dwData["VAWKWRKABT"].ToString(); 
          or1.Parameters.Add("VAWWERK", OracleType.NVarChar).Value = dwData["VAWWERK"].ToString(); 
          or1.Parameters.Add("VAWABT", OracleType.NVarChar).Value = dwData["VAWABT"].ToString(); 
          or1.Parameters.Add("VAWSWRKABT", OracleType.NVarChar).Value = dwData["VAWSWRKABT"].ToString(); 
          or1.Parameters.Add("VAWVWRKABT", OracleType.NVarChar).Value = dwData["VAWVWRKABT"].ToString(); 
          or1.Parameters.Add("VAWKDART", OracleType.NVarChar).Value = dwData["VAWKDART"].ToString(); 
          or1.Parameters.Add("VAWDART", OracleType.NVarChar).Value = dwData["VAWDART"].ToString(); 
          or1.Parameters.Add("VAWDVAR", OracleType.NVarChar).Value = dwData["VAWDVAR"].ToString(); 
          or1.Parameters.Add("VAWSDART", OracleType.NVarChar).Value = dwData["VAWSDART"].ToString(); 
          or1.Parameters.Add("VAWVDART", OracleType.NVarChar).Value = dwData["VAWVDART"].ToString(); 
          or1.Parameters.Add("VAWKPART", OracleType.NVarChar).Value = dwData["VAWKPART"].ToString(); 
          or1.Parameters.Add("VAWPWAKZ", OracleType.NVarChar).Value = dwData["VAWPWAKZ"].ToString(); 
          or1.Parameters.Add("VAWPART", OracleType.NVarChar).Value = dwData["VAWPART"].ToString(); 
          or1.Parameters.Add("VAWPVAR", OracleType.NVarChar).Value = dwData["VAWPVAR"].ToString(); 
          or1.Parameters.Add("VAWSPART", OracleType.NVarChar).Value = dwData["VAWSPART"].ToString(); 
          or1.Parameters.Add("VAWVPART", OracleType.NVarChar).Value = dwData["VAWVPART"].ToString(); 
          or1.Parameters.Add("VAWKPLART", OracleType.NVarChar).Value = dwData["VAWKPLART"].ToString(); 
          or1.Parameters.Add("VAWPLART", OracleType.NVarChar).Value = dwData["VAWPLART"].ToString(); 
          or1.Parameters.Add("VAWSPLART", OracleType.NVarChar).Value = dwData["VAWSPLART"].ToString(); 
          or1.Parameters.Add("VAWVPLART", OracleType.NVarChar).Value = dwData["VAWVPLART"].ToString(); 
          or1.Parameters.Add("VAWKFFARBE", OracleType.NVarChar).Value = dwData["VAWKFFARBE"].ToString(); 
          or1.Parameters.Add("VAWFFARBE", OracleType.NVarChar).Value = dwData["VAWFFARBE"].ToString(); 
          or1.Parameters.Add("VAWSFFARBE", OracleType.NVarChar).Value = dwData["VAWSFFARBE"].ToString(); 
          or1.Parameters.Add("VAWVFFARBE", OracleType.NVarChar).Value = dwData["VAWVFFARBE"].ToString(); 
          or1.Parameters.Add("VAWKDESS", OracleType.NVarChar).Value = dwData["VAWKDESS"].ToString(); 
          or1.Parameters.Add("VAWDESS", OracleType.NVarChar).Value = dwData["VAWDESS"].ToString(); 
          or1.Parameters.Add("VAWSDESS", OracleType.NVarChar).Value = dwData["VAWSDESS"].ToString(); 
          or1.Parameters.Add("VAWVDESS", OracleType.NVarChar).Value = dwData["VAWVDESS"].ToString(); 
          or1.Parameters.Add("VAWKCOLORIT", OracleType.NVarChar).Value = dwData["VAWKCOLORIT"].ToString(); 
          or1.Parameters.Add("VAWCOLORIT", OracleType.NVarChar).Value = dwData["VAWCOLORIT"].ToString(); 
          or1.Parameters.Add("VAWSCOLORIT", OracleType.NVarChar).Value = dwData["VAWSCOLORIT"].ToString(); 
          or1.Parameters.Add("VAWVCOLORIT", OracleType.NVarChar).Value = dwData["VAWVCOLORIT"].ToString(); 
          or1.Parameters.Add("VAWKBESCHICH", OracleType.NVarChar).Value = dwData["VAWKBESCHICH"].ToString(); 
          or1.Parameters.Add("VAWBESCHICH", OracleType.NVarChar).Value = dwData["VAWBESCHICH"].ToString(); 
          or1.Parameters.Add("VAWSBESCHICH", OracleType.NVarChar).Value = dwData["VAWSBESCHICH"].ToString(); 
          or1.Parameters.Add("VAWVBESCHICH", OracleType.NVarChar).Value = dwData["VAWVBESCHICH"].ToString(); 
          or1.Parameters.Add("VAWVONST", OracleType.NVarChar).Value = dwData["VAWVONST"].ToString(); 
          or1.Parameters.Add("VAWANZST", OracleType.NVarChar).Value = dwData["VAWANZST"].ToString(); 
          or1.Parameters.Add("VAWKUMSATZ4", OracleType.NVarChar).Value = dwData["VAWKUMSATZ4"].ToString(); 
          or1.Parameters.Add("VAWUMSATZV", OracleType.NVarChar).Value = dwData["VAWUMSATZV"].ToString(); 
          or1.Parameters.Add("VAWUMSATZB", OracleType.NVarChar).Value = dwData["VAWUMSATZB"].ToString(); 
          or1.Parameters.Add("VAWSUMSATZ", OracleType.NVarChar).Value = dwData["VAWSUMSATZ"].ToString(); 
          or1.Parameters.Add("VAWVUMSATZ", OracleType.NVarChar).Value = dwData["VAWVUMSATZ"].ToString(); 
          or1.Parameters.Add("VAWKDB4", OracleType.NVarChar).Value = dwData["VAWKDB4"].ToString(); 
          or1.Parameters.Add("VAWINDEX", OracleType.NVarChar).Value = dwData["VAWINDEX"].ToString(); 
          or1.Parameters.Add("VAWDBV", OracleType.NVarChar).Value = dwData["VAWDBV"].ToString(); 
          or1.Parameters.Add("VAWDBB", OracleType.NVarChar).Value = dwData["VAWDBB"].ToString(); 
          or1.Parameters.Add("VAWSDB4", OracleType.NVarChar).Value = dwData["VAWSDB4"].ToString(); 
          or1.Parameters.Add("VAWVDB4", OracleType.NVarChar).Value = dwData["VAWVDB4"].ToString(); 
          or1.Parameters.Add("VAWKLITERM", OracleType.NVarChar).Value = dwData["VAWKLITERM"].ToString(); 
          or1.Parameters.Add("VAWLITERMV", OracleType.NVarChar).Value = dwData["VAWLITERMV"].ToString(); 
          or1.Parameters.Add("VAWLITERMB", OracleType.NVarChar).Value = dwData["VAWLITERMB"].ToString(); 
          or1.Parameters.Add("VAWSLITERM", OracleType.NVarChar).Value = dwData["VAWSLITERM"].ToString(); 
          or1.Parameters.Add("VAWVLITERM", OracleType.NVarChar).Value = dwData["VAWVLITERM"].ToString(); 
          or1.Parameters.Add("VAWKAUFTR", OracleType.NVarChar).Value = dwData["VAWKAUFTR"].ToString(); 
          or1.Parameters.Add("VAWAUFKRS", OracleType.NVarChar).Value = dwData["VAWAUFKRS"].ToString(); 
          or1.Parameters.Add("VAWAUFLFD", OracleType.NVarChar).Value = dwData["VAWAUFLFD"].ToString(); 
          or1.Parameters.Add("VAWAUFPOS", OracleType.NVarChar).Value = dwData["VAWAUFPOS"].ToString(); 
          or1.Parameters.Add("VAWSAUFTR", OracleType.NVarChar).Value = dwData["VAWSAUFTR"].ToString(); 
          or1.Parameters.Add("VAWVAUFTR", OracleType.NVarChar).Value = dwData["VAWVAUFTR"].ToString(); 
          or1.Parameters.Add("VAWKRECH", OracleType.NVarChar).Value = dwData["VAWKRECH"].ToString(); 
          or1.Parameters.Add("VAWRENR", OracleType.NVarChar).Value = dwData["VAWRENR"].ToString(); 
          or1.Parameters.Add("VAWREPOS", OracleType.NVarChar).Value = dwData["VAWREPOS"].ToString(); 
          or1.Parameters.Add("VAWREDAT", OracleType.NVarChar).Value = dwData["VAWREDAT"].ToString(); 
          or1.Parameters.Add("VAWSRECH", OracleType.NVarChar).Value = dwData["VAWSRECH"].ToString(); 
          or1.Parameters.Add("VAWVRECH", OracleType.NVarChar).Value = dwData["VAWVRECH"].ToString(); 
          or1.Parameters.Add("VAWKVZOLLTNR", OracleType.NVarChar).Value = dwData["VAWKVZOLLTNR"].ToString(); 
          or1.Parameters.Add("VAWVZOLLTNR", OracleType.NVarChar).Value = dwData["VAWVZOLLTNR"].ToString(); 
          or1.Parameters.Add("VAWSVZOLLTNR", OracleType.NVarChar).Value = dwData["VAWSVZOLLTNR"].ToString(); 
          or1.Parameters.Add("VAWVVZOLLTNR", OracleType.NVarChar).Value = dwData["VAWVVZOLLTNR"].ToString(); 
          or1.Parameters.Add("VAWKSTATWNR", OracleType.NVarChar).Value = dwData["VAWKSTATWNR"].ToString(); 
          or1.Parameters.Add("VAWSTATWNR", OracleType.NVarChar).Value = dwData["VAWSTATWNR"].ToString(); 
          or1.Parameters.Add("VAWSSTATWNR", OracleType.NVarChar).Value = dwData["VAWSSTATWNR"].ToString(); 
          or1.Parameters.Add("VAWVSTATWNR", OracleType.NVarChar).Value = dwData["VAWVSTATWNR"].ToString(); 
          or1.Parameters.Add("VAWKBUSIMODE", OracleType.NVarChar).Value = dwData["VAWKBUSIMODE"].ToString(); 
          or1.Parameters.Add("VAWBUSIMODE", OracleType.NVarChar).Value = dwData["VAWBUSIMODE"].ToString(); 
          or1.Parameters.Add("VAWSBUSIMODE", OracleType.NVarChar).Value = dwData["VAWSBUSIMODE"].ToString(); 
          or1.Parameters.Add("VAWVBUSIMODE", OracleType.NVarChar).Value = dwData["VAWVBUSIMODE"].ToString(); 
          or1.Parameters.Add("VAWKTITER", OracleType.NVarChar).Value = dwData["VAWKTITER"].ToString(); 
          or1.Parameters.Add("VAWNUMART", OracleType.NVarChar).Value = dwData["VAWNUMART"].ToString(); 
          or1.Parameters.Add("VAWGARNNR1", OracleType.NVarChar).Value = dwData["VAWGARNNR1"].ToString(); 
          or1.Parameters.Add("VAWGARNNR2", OracleType.NVarChar).Value = dwData["VAWGARNNR2"].ToString(); 
          or1.Parameters.Add("VAWSTITER", OracleType.NVarChar).Value = dwData["VAWSTITER"].ToString(); 
          or1.Parameters.Add("VAWVTITER", OracleType.NVarChar).Value = dwData["VAWVTITER"].ToString(); 
          or1.Parameters.Add("VAWKURSPPART", OracleType.NVarChar).Value = dwData["VAWKURSPPART"].ToString(); 
          or1.Parameters.Add("VAWURSPPART", OracleType.NVarChar).Value = dwData["VAWURSPPART"].ToString(); 
          or1.Parameters.Add("VAWSURSPPART", OracleType.NVarChar).Value = dwData["VAWSURSPPART"].ToString(); 
          or1.Parameters.Add("VAWVURSPPART", OracleType.NVarChar).Value = dwData["VAWVURSPPART"].ToString(); 
          or1.Parameters.Add("VAWKSPPART", OracleType.NVarChar).Value = dwData["VAWKSPPART"].ToString(); 
          or1.Parameters.Add("VAWSPPART", OracleType.NVarChar).Value = dwData["VAWSPPART"].ToString(); 
          or1.Parameters.Add("VAWSSPPART", OracleType.NVarChar).Value = dwData["VAWSSPPART"].ToString(); 
          or1.Parameters.Add("VAWVSPPART", OracleType.NVarChar).Value = dwData["VAWVSPPART"].ToString(); 
          or1.Parameters.Add("VAWKKUNDNRKO", OracleType.NVarChar).Value = dwData["VAWKKUNDNRKO"].ToString(); 
          or1.Parameters.Add("VAWKUNDNRKO", OracleType.NVarChar).Value = dwData["VAWKUNDNRKO"].ToString(); 
          or1.Parameters.Add("VAWSKUNDNRKO", OracleType.NVarChar).Value = dwData["VAWSKUNDNRKO"].ToString(); 
          or1.Parameters.Add("VAWVKUNDNRKO", OracleType.NVarChar).Value = dwData["VAWVKUNDNRKO"].ToString(); 
          or1.Parameters.Add("VAWKFARBGRP", OracleType.NVarChar).Value = dwData["VAWKFARBGRP"].ToString(); 
          or1.Parameters.Add("VAWFARBGRP", OracleType.NVarChar).Value = dwData["VAWFARBGRP"].ToString(); 
          or1.Parameters.Add("VAWSFARBGRP", OracleType.NVarChar).Value = dwData["VAWSFARBGRP"].ToString(); 
          or1.Parameters.Add("VAWVFARBGRP", OracleType.NVarChar).Value = dwData["VAWVFARBGRP"].ToString(); 
          or1.Parameters.Add("VAWKKDKOLL", OracleType.NVarChar).Value = dwData["VAWKKDKOLL"].ToString(); 
          or1.Parameters.Add("VAWKDKOLL", OracleType.NVarChar).Value = dwData["VAWKDKOLL"].ToString(); 
          or1.Parameters.Add("VAWSKDKOLL", OracleType.NVarChar).Value = dwData["VAWSKDKOLL"].ToString(); 
          or1.Parameters.Add("VAWVKDKOLL", OracleType.NVarChar).Value = dwData["VAWVKDKOLL"].ToString(); 
          or1.Parameters.Add("VAWKMKOLL", OracleType.NVarChar).Value = dwData["VAWKMKOLL"].ToString(); 
          or1.Parameters.Add("VAWMKOLL", OracleType.NVarChar).Value = dwData["VAWMKOLL"].ToString(); 
          or1.Parameters.Add("VAWSMKOLL", OracleType.NVarChar).Value = dwData["VAWSMKOLL"].ToString(); 
          or1.Parameters.Add("VAWVMKOLL", OracleType.NVarChar).Value = dwData["VAWVMKOLL"].ToString(); 
          or1.Parameters.Add("VAWFILLER2", OracleType.NVarChar).Value = dwData["VAWFILLER2"].ToString(); 
          or1.Parameters.Add("VAWSEITE", OracleType.NVarChar).Value = dwData["VAWSEITE"].ToString(); 
          or1.Parameters.Add("VAWKUNDKZ", OracleType.NVarChar).Value = dwData["VAWKUNDKZ"].ToString(); 
          or1.Parameters.Add("VAWVARTKZ", OracleType.NVarChar).Value = dwData["VAWVARTKZ"].ToString(); 
          or1.Parameters.Add("VAWUMSATZKZ", OracleType.NVarChar).Value = dwData["VAWUMSATZKZ"].ToString(); 
          or1.Parameters.Add("VAWKZKUNDE", OracleType.NVarChar).Value = dwData["VAWKZKUNDE"].ToString(); 
          or1.Parameters.Add("VAWMATKOMP", OracleType.NVarChar).Value = dwData["VAWMATKOMP"].ToString(); 
          or1.Parameters.Add("VAWKMORD", OracleType.NVarChar).Value = dwData["VAWKMORD"].ToString(); 
          or1.Parameters.Add("VAWSMORD", OracleType.NVarChar).Value = dwData["VAWSMORD"].ToString(); 
          or1.Parameters.Add("VAWVMORD", OracleType.NVarChar).Value = dwData["VAWVMORD"].ToString(); 
          or1.Parameters.Add("VAWFILLER", OracleType.NVarChar).Value = dwData["VAWFILLER"].ToString(); 
          or1.Parameters.Add("VAWAENZL", OracleType.NVarChar).Value = dwData["VAWAENZL"].ToString(); 
          or1.Parameters.Add("VAWAENB", OracleType.NVarChar).Value = dwData["VAWAENB"].ToString(); 
          or1.Parameters.Add("VAWAEND", OracleType.NVarChar).Value = dwData["VAWAEND"].ToString(); 
          or1.Parameters.Add("VAWNEUB", OracleType.NVarChar).Value = dwData["VAWNEUB"].ToString(); 
          or1.Parameters.Add("VAWNEUD", OracleType.NVarChar).Value = dwData["VAWNEUD"].ToString(); 
                    #endregion
                    break; 
                default:
                    break;
            }


            Connect2Proxy(or1);
        }
    }
}
